Re: [Zope] PyGres DB Connection in Zope drops when many Users are added (UserDB) (UserDB)

Have you tried running AB against some of the pages and watching the
connections happen? Also, try playing around with the cache. I found
that I could change the load times and db performance by playing with
Zope db caching.  I would also hate to mention it but 7 is still
beta. Can you try it on 6.5.3 and see if it still happens?

J


At 1:19 AM -0500 4/25/2000, Stephan Richter wrote:
>Hello everyone,
>
>This is a help message to every mailing list, I think this issue
>could be related to. We are in production and 5000 flyers (45000
>follow) were sent out and the site keeps giving problems.
>
>I use:
>Zope 2.1.4, PyGres 2.x, Apache, and PostGres 7.0RC1
>
>The issue:
>It seems like that whenever "many" (10, I know that is not much)
>people sign up at the same time on our Web Site
>(http://www.plandepot.com), we loose the DB connection. The
>connection is simple restored, when disconnecting and the
>reconnecting the database.
>Unfortunately I was unable to reproduce the error outside of
>business hours, so I had never the chance to inspect the issue in
>detail. I personally do not think it is PostGreSQL or Zope, since I
>would have read more about it.
>I have to mention, that PyGres is not thread safe and by default
>Zope uses more than one thread if required. So could that be the
>issue? How do I setup Zope in a way, that it uses only one thread?
>Also, I do not use any of the caching features in Zope SQL Methods
>either.